Param( ).Direction

This property indicates whether the Parameter represents an input parameter, an output parameter, or both, or if the parameter is the return value from a stored procedure.

Group: Stored Procedure Object

Syntax: StoredProc.Param(nIndex).Direction = enValue

Alternate: nValue = StoredProc.Param(nIndex).Direction

nIndex     (Long) index of the parameter

nValue     (Long) the numeric value of an enDirections value

enValue   (enDirections) sets or returns one of the following values:

Constant                          Description

dbParamInput                  Default, indicates an input parameter

dbParamOutput                Indicates an output parameter

dbParamInputOutput        Indicates both an input and output parameter

dbParamReturnValue       Indicates a return value.